package com.suvel.study.dao;

import com.suvel.study.pojo.LagouAuthCode;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface CodeDao extends JpaRepository<LagouAuthCode,Long> {
    @Query(value = "select * from lagou_auth_code where email = ?1 order by createtime desc limit 1", nativeQuery = true)
    LagouAuthCode findLastCodeByEmail(String email);
}
